
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_MonHoc_GetTotalMonHocByTen]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[sp_MonHoc_GetTotalMonHocByTen]
GO
create procedure sp_MonHoc_GetTotalMonHocByTen
	@TenMH nvarchar(100)
as
begin			
		SELECT COUNT(MaMH) As Total   
				FROM MonHoc
				WHERE MonHoc.Ten_MH like @TenMH
end



